Q Overview In this activity, you’ll answer the questions by summarizing the results, analyzing the data, and using the information gathered. Directions Your team has been given several data sets in order to analyze information and summarize the findings. These are in the form of simple return merchandise authorizations (RMAs). Your task is to write brief summaries that show the results of the analysis to present to the product manager, who may or may not have a technical background. This is why you should write the summaries for an audience of nontechnical stakeholders. Write a detailed summary of your analysis of the items below. Prepare your summary for nontechnical stakeholders. Use the list below to guide the structure and organization of your report. 1. Write SQL commands that capture specific, usable data that can be used in your analysis. 2. Analyze the results of queries to identify specific information that can be presented in your summary. A. Sales by region: i. Analyze sales data by state to determine where the company has the largest customer base. ii. Analyze the data to determine the top three products sold in the United States. iii. Analyze the data to determine the top three products sold in the southeastern region of the United States. ? Southeastern states to include in your analysis: Virginia, North Carolina, South Carolina, and Georgia B. Returns by region: i. Analyze the data to determine the top three products returned in the United States. ii. Analyze the data to determine the top three products returned in the northwestern region of the United States. ? Northwestern states to include in your analysis: Washington, Oregon, Idaho, and Montana 3. Write a report to the Quantigration product manager that explains your findings in a way nontechnical stakeholders can digest and use. A. This report should include an effective summary of the analysis of the captured data. i. Sales data by region: Provide a well-written summary of your analysis on Part A. ii. Returns data by region: Provide a well-written summary of your analysis of Part B. What to Submit Submit your report as a Microsoft Word document with double spacing, 12-point Times New Roman font, and one-inch margins. Any references cited must be in APA format. Consult the Academic Support module in your course for more information on citations. Module Five Major Activity Rubric Criteria Proficient (100%) Needs Improvement (75%) Not Evident (0%) Value Write SQL Commands Writes SQL commands that capture specific, usable data that can be used in the analysis Shows progress toward proficiency, but with errors or omissions; areas for improvement may include queries that do not address the identified data Does not attempt criterion 25 Analyze Results of Queries Analyzes the results of queries to identify specific information that can be presented in a summary Shows progress toward proficiency, but with errors or omissions; areas for improvement may include accuracy of analysis Does not attempt criterion 25 Write a Report Writes a report to the Quantigration product manager that explains findings in a way nontechnical stakeholders can digest and use Shows progress toward proficiency, but with errors or omissions; areas for improvement may include more details to support the report or communicating all parts of the analysis more clearly Does not attempt criterion 25 Articulation of Response Clearly conveys meaning with correct grammar, sentence structure, and spelling, demonstrating an understanding of audience and purpose Shows progress toward proficiency, but with errors in grammar, sentence structure, and spelling, negatively impacting readability Submission has critical errors in grammar, sentence structure, and spelling, preventing understanding of ideas 25 Total: 100%